EMT Practice Test

1. Question Content...

---

Question1: An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state.
Which two restore options could be used? (Choose two.)

Question2: An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases.
How does NDB handle this database restore operation?

Question3: Which statement describes a user in Era with the Database Infrastructure Admin role?

Question4: Which action must an administrator take in Era Networks before using Era to provision a MSSQL AG cluster?

Question5: An administrator is tasked with auditing NDB SLAs.
What data will the administrator be reviewing?

Question6: An administrator needs to create a custom PostgreSQL HA software profile.
Which software component manages the state of the cluster and handles failover?

Question7: Refer to the exhibit.

An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.
What is most likely the cause of the issue?

Question8: Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.
Where should the database data and log files be located in order to successfully complete this task?

Question9: An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.
Which step should the administrator take before applying the patch?

Question10: An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.
What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?

Question11: How should an administrator modify the Alert Severity level within Era?

Question12: When registering SAP HANA Database and Database Server VM there are several (Linux) OS configuration requirements that must be set before registering a database Or a database server VM.
Which system file should the entry, secure_pazh be configured in?

Question13: A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

Question14: Which default roles are available within Era for Role-Based Access Control?

Question15: Which disk is omitted from a Software Profile?

Question16: An administrator needs to take multiple snapshots per day and retain them for one week.
How should the administrator define and schedule the SLA?

Question17: What are the three severity levels displayed under the Alert dashboard?

Question18: What is required to cre110ate a network profile in Era?

Question19: A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?

Question20: An administrator needs the ability to clone a source database to a point in time.
What is the lowest log frequency in minutes that can be configured in the Era IJI for log catchup operation?

Question21: Where are two locations an administrator would find the size of a Source Database? (Choose two.)

Question22: An administrator enables NDB Multi-Cluster on Cluster A. Cluster B is then registered with NDB.
What are the different NDB Service VMs present in each Nutanix cluster?

Question23: An administrator has created a new SQL Server software profile version to apply the latest cumulative update.
What should the administrator do to make it available to all users?

Question24: A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes.
The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?

Question25: An administrator is trying to register a Nutanix cluster for Multi-Cluster provisioning.
The Era cluster is setup with following configuration:
* Era Multi-Cluster is enabled.
Era Server storage container and Era provisioning container are different on the Era cluster.
What should the administrator configure?

Question26: An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout.
How should the storage be provisioned with Era to support the database while optimizing performance?

Question27: Which NDB feature collects logs and snapshots from databases?

Question28: An administrator has received a request to clone a source production database to an existing development server.
Which two actions must be taken to complete this task?

Question29: An administrator is interested in using profiles to simplify the database provisioning process. The profile needs to include information related to the SQL service startup account, and the NDB worker service account.
Which profile would help the administrator accomplish this task?

Question30: An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?

Question31: An administrator was asked to change the snapshot schedule for a given database. The administrator discovered that the time machine is in a paused state.
How should the administrator change the schedule?

Question32: An administrator needs to roll back an Oracle patch on a database server VM using NDB.
What is required for this action to be successful?

Question33: An administrator has applied an Oracle security patch to a database server VM registered in Era.
How do you make this change available to other existing database instances?

Question34: How is a software profile created?

Question35: Which command can be used to assign a static IP address to the Era VM on ESXi?
set
era-server > era
era-server >
An administrator is trying to register an Oracle Database Server VM to Era.
Which dependency must be met?

Question36: When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore Location as New Location?

Question37: While registering an Always on Availability Group database, an administrator selects the following option:
Multiple Databases as a Group with One Time Machine
Which statement is true regarding this chosen option?

Question38: Which two encryption methods can be used when configuring an SMTP server? (Choose two.)

Question39: Which policies define Time Machine data availability across multiple registered clusters in NDB?

Question40: What must be completed within NDB before patching a Linux OS?

Question41: When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?

Question42: An administrator needs to replace the default Nutanix self-signed certificates in Era.
Which SSL Certificate file format is supported?

Question43: How should an administrator create a database clone using the Era IJI?

Question44: An administrator would like to replicate database snapshots to remote Nutanix clusters.
What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?

Question45: An administrator needs to protect a database with a Point In Time Recovery (PITR) SLA that provides a minimum of seven days of log recovery.
What is the minimum Default SLA that meets this requirement?

Question46: An administrator has a production PostgreSQL database cloned for development and testing purpose. A new table is added to the source database.
What should the administrator do to publish the update leveraging the point in Time Era capability?
(C) 1. PeHorm a Log Catch-up using source database Time Mechine 2. Refresh the clone database (C) 1. Perform a Log Catch-up using source database Time Mechine
2. Refresh the source database
(C) l. update Log Catch-up interval from Tme Machine 2. Refresh the source database C) 1. Update Log Catch-up interval from Tame Machine 2. Refresh the clone database How is the size of a database time machine defined?

Question47: A database administrator is tasked with creating a new clone of a running SQL database. During the clone process, there are no authorized servers are available.
What should the administrator do next?

Question48: A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the development cluster.
Which two profiles should the administrator adjust to get the copy to fit within the resources available?
(Choose two.)

Question49: How long is the default continuous recovery for the Gold SLA in Era Time Machine?

Question50: The NDB user interface can display which language option?

Question51: What does a Time Machine frozen status indicate?

Question52: An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.
At a minimum, how much space must be available for Grid home prior to completing this task?

Question53: A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.
What should the database admin do?

Question54: What is the purpose of Data Access Management policies in NDB Multi-Cluster?

Question55: Which Era component collects logs and snapshots from the database?

Question56: An administrator selected Bronze SLA for Era Time Machine during database registration.
Which two capabilities are supported by the Time Machine for this database? (Choose two,)

Question57: An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.
What needs to be done to expose the new VLANs for provisioning?

Question58: Which two ports can be used by external applications to make API calls to Era? (Choose two.)

Question59: Why are ports 3205 and 3260 important when working with Era?

Question60: How would an administrator enter the NDB command line to change the static IP address on the NDB VM?

Question61: An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days.
After selecting the desired clone, how should the administrator satisfy this task?

Question62: For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?

Question63: An administrator needs to distribute NDB management plane components.
Which NDB HA VM needs to be deployed on the same L2 network?

Question64: What does an NDB compute profile contain?

Question65: How does NDB send notifications when alerts are generated?

Question66: What are two status values that can be set within the Alerts Dashboard? (Choose two.)

Question67: When an Oracle database is upgraded using Era, what is the type of upgrade category?

Question68: What feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration?